<?php

	# These are all SQL entries used in Codename: STIMPy!
	# Each is separated into INSERT's, SELECT's, and UPDATE's
	
	##################
	# SELECT queries #
	##################
	
	# Query for SQL_get_OL_users
	define(SQL_get_OL_users,"SELECT * FROM `users` WHERE `logged` IS NOT NULL");
	
	# Query for SQL_get_regd_users
	define(SQL_get_regd_users,"SELECT * FROM `users`");
	
	# Query for SQL_get_latest_news
	define(SQL_get_latest_news,"SELECT topic_title, post_time, post_text FROM phpbb".(page_location=='web'?"_dev":"")."_topics AS t
LEFT JOIN phpbb".(page_location=='web'?"_dev":"")."_posts AS p ON t.topic_first_post_id=p.post_id
LEFT JOIN phpbb".(page_location=='web'?"_dev":"")."_posts_text AS pt ON p.post_id=pt.post_id
WHERE t.forum_id=".(page_location=='web'?8:1)."
ORDER BY p.post_time DESC
LIMIT 0,3");

	//define(SQL_get_username,"SELECT * from users where UN='{$username}'");
	
	##################
	# INSERT queries #
	##################
	
	##################
	# UPDATE queries #
	##################

?>